Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 341 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 40.1 KiB |
| Average record size in memory | 120.4 B |
Variable types
| Unsupported | 1 |
|---|---|
| Categorical | 2 |
| Numeric | 12 |
Symbol has constant value "RELIANCE" | Constant |
Series has constant value "EQ" | Constant |
Prev Close is highly correlated with Open and 5 other fields | High correlation |
Open is highly correlated with Prev Close and 5 other fields | High correlation |
High is highly correlated with Prev Close and 5 other fields | High correlation |
Low is highly correlated with Prev Close and 5 other fields | High correlation |
Last is highly correlated with Prev Close and 5 other fields | High correlation |
Close is highly correlated with Prev Close and 5 other fields | High correlation |
VWAP is highly correlated with Prev Close and 5 other fields | High correlation |
Volume is highly correlated with Turnover and 2 other fields | High correlation |
Turnover is highly correlated with Volume and 2 other fields | High correlation |
Trades is highly correlated with Volume and 2 other fields | High correlation |
Deliverable Volume is highly correlated with Volume and 2 other fields | High correlation |
Series is highly correlated with Symbol | High correlation |
Symbol is highly correlated with Series | High correlation |
VWAP has unique values | Unique |
Volume has unique values | Unique |
Turnover has unique values | Unique |
Trades has unique values | Unique |
Deliverable Volume has unique values | Unique |
Date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2022-09-11 04:24:12.961542 |
|---|---|
| Analysis finished | 2022-09-11 04:25:03.258495 |
| Duration | 50.3 seconds |
| Software version | pandas-profiling v3.3.0 |
| Download configuration | config.json |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 KiB |
| RELIANCE |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2728 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RELIANCE |
|---|---|
| 2nd row | RELIANCE |
| 3rd row | RELIANCE |
| 4th row | RELIANCE |
| 5th row | RELIANCE |
Common Values
| Value | Count | Frequency (%) |
| RELIANCE | 341 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| reliance | 341 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 682 | |
| R | 341 | |
| L | 341 | |
| I | 341 | |
| A | 341 | |
| N | 341 | |
| C | 341 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2728 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 682 | |
| R | 341 | |
| L | 341 | |
| I | 341 | |
| A | 341 | |
| N | 341 | |
| C | 341 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2728 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 682 | |
| R | 341 | |
| L | 341 | |
| I | 341 | |
| A | 341 | |
| N | 341 | |
| C | 341 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2728 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 682 | |
| R | 341 | |
| L | 341 | |
| I | 341 | |
| A | 341 | |
| N | 341 | |
| C | 341 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 KiB |
| EQ |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 682 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EQ |
|---|---|
| 2nd row | EQ |
| 3rd row | EQ |
| 4th row | EQ |
| 5th row | EQ |
Common Values
| Value | Count | Frequency (%) |
| EQ | 341 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| eq | 341 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 341 | |
| Q | 341 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 682 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 341 | |
| Q | 341 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 682 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 341 | |
| Q | 341 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 682 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 341 | |
| Q | 341 |
| Distinct | 335 |
|---|---|
| Distinct (%) | 98.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2404.766862 |
| Minimum | 1913.15 |
|---|---|
| Maximum | 2819.85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1913.15 |
|---|---|
| 5-th percentile | 1997.05 |
| Q1 | 2244.9 |
| median | 2423.9 |
| Q3 | 2572.85 |
| 95-th percentile | 2700.4 |
| Maximum | 2819.85 |
| Range | 906.7 |
| Interquartile range (IQR) | 327.95 |
Descriptive statistics
| Standard deviation | 213.8930387 |
|---|---|
| Coefficient of variation (CV) | 0.08894543669 |
| Kurtosis | -0.5672917834 |
| Mean | 2404.766862 |
| Median Absolute Deviation (MAD) | 156.25 |
| Skewness | -0.4665628634 |
| Sum | 820025.5 |
| Variance | 45750.232 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2627.4 | 2 | 0.6% |
| 2425.6 | 2 | 0.6% |
| 2086 | 2 | 0.6% |
| 2227.4 | 2 | 0.6% |
| 2378.3 | 2 | 0.6% |
| 2700.4 | 2 | 0.6% |
| 1997.3 | 1 | 0.3% |
| 2626.05 | 1 | 0.3% |
| 2663.7 | 1 | 0.3% |
| 2655.85 | 1 | 0.3% |
| Other values (325) | 325 |
| Value | Count | Frequency (%) |
| 1913.15 | 1 | |
| 1916.6 | 1 | |
| 1920.1 | 1 | |
| 1926.2 | 1 | |
| 1931 | 1 | |
| 1931.75 | 1 | |
| 1933.15 | 1 | |
| 1937.3 | 1 | |
| 1959.05 | 1 | |
| 1960.35 | 1 |
| Value | Count | Frequency (%) |
| 2819.85 | 1 | |
| 2798.75 | 1 | |
| 2790.25 | 1 | |
| 2782.1 | 1 | |
| 2780.45 | 1 | |
| 2779.5 | 1 | |
| 2778.35 | 1 | |
| 2775.65 | 1 | |
| 2772.75 | 1 | |
| 2767.55 | 1 |
| Distinct | 315 |
|---|---|
| Distinct (%) | 92.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2406.898094 |
| Minimum | 1915 |
|---|---|
| Maximum | 2856.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1915 |
|---|---|
| 5-th percentile | 1997.9 |
| Q1 | 2250 |
| median | 2430.95 |
| Q3 | 2574.9 |
| 95-th percentile | 2710 |
| Maximum | 2856.15 |
| Range | 941.15 |
| Interquartile range (IQR) | 324.9 |
Descriptive statistics
| Standard deviation | 212.9058893 |
|---|---|
| Coefficient of variation (CV) | 0.08845654489 |
| Kurtosis | -0.5570421691 |
| Mean | 2406.898094 |
| Median Absolute Deviation (MAD) | 151.7 |
| Skewness | -0.4628813499 |
| Sum | 820752.25 |
| Variance | 45328.91769 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2400 | 3 | 0.9% |
| 2452 | 3 | 0.9% |
| 2600 | 3 | 0.9% |
| 2560 | 3 | 0.9% |
| 2610 | 3 | 0.9% |
| 2430 | 2 | 0.6% |
| 2174 | 2 | 0.6% |
| 2380 | 2 | 0.6% |
| 2373 | 2 | 0.6% |
| 2058 | 2 | 0.6% |
| Other values (305) | 316 |
| Value | Count | Frequency (%) |
| 1915 | 1 | |
| 1921.85 | 1 | |
| 1923.35 | 1 | |
| 1928.05 | 1 | |
| 1930.1 | 1 | |
| 1937.3 | 1 | |
| 1937.75 | 1 | |
| 1939 | 1 | |
| 1950 | 1 | |
| 1966 | 1 |
| Value | Count | Frequency (%) |
| 2856.15 | 1 | |
| 2809.95 | 1 | |
| 2785 | 1 | |
| 2780 | 1 | |
| 2772.75 | 1 | |
| 2771.9 | 1 | |
| 2769.9 | 1 | |
| 2762 | 1 | |
| 2758.9 | 1 | |
| 2755.85 | 1 |
| Distinct | 328 |
|---|---|
| Distinct (%) | 96.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2433.616569 |
| Minimum | 1932.9 |
|---|---|
| Maximum | 2856.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1932.9 |
|---|---|
| 5-th percentile | 2016.45 |
| Q1 | 2275.85 |
| median | 2457 |
| Q3 | 2598.75 |
| 95-th percentile | 2742.75 |
| Maximum | 2856.15 |
| Range | 923.25 |
| Interquartile range (IQR) | 322.9 |
Descriptive statistics
| Standard deviation | 216.9498059 |
|---|---|
| Coefficient of variation (CV) | 0.08914707793 |
| Kurtosis | -0.5298882719 |
| Mean | 2433.616569 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | -0.4741761527 |
| Sum | 829863.25 |
| Variance | 47067.21829 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2425 | 2 | 0.6% |
| 2235 | 2 | 0.6% |
| 2500 | 2 | 0.6% |
| 2610 | 2 | 0.6% |
| 2638 | 2 | 0.6% |
| 2570 | 2 | 0.6% |
| 2606 | 2 | 0.6% |
| 2405 | 2 | 0.6% |
| 2442 | 2 | 0.6% |
| 2598.75 | 2 | 0.6% |
| Other values (318) | 321 |
| Value | Count | Frequency (%) |
| 1932.9 | 1 | |
| 1935 | 1 | |
| 1938.5 | 1 | |
| 1938.55 | 1 | |
| 1942 | 1 | |
| 1946.8 | 1 | |
| 1955.65 | 1 | |
| 1963.45 | 1 | |
| 1967.8 | 1 | |
| 1979 | 1 |
| Value | Count | Frequency (%) |
| 2856.15 | 1 | |
| 2851 | 1 | |
| 2828 | 1 | |
| 2817.35 | 1 | |
| 2814 | 1 | |
| 2805.5 | 1 | |
| 2803 | 1 | |
| 2802 | 1 | |
| 2795 | 1 | |
| 2791.1 | 1 |
| Distinct | 323 |
|---|---|
| Distinct (%) | 94.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2380.575513 |
| Minimum | 1906 |
|---|---|
| Maximum | 2786.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1906 |
|---|---|
| 5-th percentile | 1986 |
| Q1 | 2234.15 |
| median | 2404 |
| Q3 | 2547.35 |
| 95-th percentile | 2669.3 |
| Maximum | 2786.1 |
| Range | 880.1 |
| Interquartile range (IQR) | 313.2 |
Descriptive statistics
| Standard deviation | 208.9268729 |
|---|---|
| Coefficient of variation (CV) | 0.08776317816 |
| Kurtosis | -0.5785960503 |
| Mean | 2380.575513 |
| Median Absolute Deviation (MAD) | 152.1 |
| Skewness | -0.4533509196 |
| Sum | 811776.25 |
| Variance | 43650.43821 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2360 | 3 | 0.9% |
| 2570 | 3 | 0.9% |
| 2495 | 3 | 0.9% |
| 2370 | 3 | 0.9% |
| 2404 | 3 | 0.9% |
| 2412 | 2 | 0.6% |
| 2461 | 2 | 0.6% |
| 2081 | 2 | 0.6% |
| 2501 | 2 | 0.6% |
| 2305 | 2 | 0.6% |
| Other values (313) | 316 |
| Value | Count | Frequency (%) |
| 1906 | 1 | |
| 1906.6 | 1 | |
| 1907 | 1 | |
| 1908.05 | 1 | |
| 1910 | 1 | |
| 1911 | 1 | |
| 1920.95 | 1 | |
| 1926 | 1 | |
| 1930.4 | 1 | |
| 1943.1 | 1 |
| Value | Count | Frequency (%) |
| 2786.1 | 1 | |
| 2777.3 | 1 | |
| 2758.05 | 1 | |
| 2755.05 | 1 | |
| 2752.05 | 1 | |
| 2751.8 | 1 | |
| 2744.2 | 1 | |
| 2742 | 1 | |
| 2732 | 1 | |
| 2716.3 | 1 |
| Distinct | 323 |
|---|---|
| Distinct (%) | 94.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2405.912023 |
| Minimum | 1913.05 |
|---|---|
| Maximum | 2810 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1913.05 |
|---|---|
| 5-th percentile | 1995.9 |
| Q1 | 2245 |
| median | 2424 |
| Q3 | 2572 |
| 95-th percentile | 2703.5 |
| Maximum | 2810 |
| Range | 896.95 |
| Interquartile range (IQR) | 327 |
Descriptive statistics
| Standard deviation | 213.0669025 |
|---|---|
| Coefficient of variation (CV) | 0.08855972307 |
| Kurtosis | -0.5486879634 |
| Mean | 2405.912023 |
| Median Absolute Deviation (MAD) | 151.3 |
| Skewness | -0.472091457 |
| Sum | 820416 |
| Variance | 45397.50496 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2090 | 3 | 0.9% |
| 2668 | 3 | 0.9% |
| 2112 | 2 | 0.6% |
| 2530 | 2 | 0.6% |
| 2225 | 2 | 0.6% |
| 2635 | 2 | 0.6% |
| 2178 | 2 | 0.6% |
| 2626 | 2 | 0.6% |
| 2382 | 2 | 0.6% |
| 2589 | 2 | 0.6% |
| Other values (313) | 319 |
| Value | Count | Frequency (%) |
| 1913.05 | 1 | |
| 1918 | 1 | |
| 1921.5 | 1 | |
| 1926.8 | 1 | |
| 1927.1 | 1 | |
| 1932 | 1 | |
| 1933.9 | 1 | |
| 1937 | 1 | |
| 1956 | 1 | |
| 1958.85 | 1 |
| Value | Count | Frequency (%) |
| 2810 | 1 | |
| 2799.7 | 1 | |
| 2796.05 | 1 | |
| 2788.2 | 1 | |
| 2782 | 1 | |
| 2780.9 | 1 | |
| 2778 | 1 | |
| 2776 | 1 | |
| 2767.05 | 1 | |
| 2766.25 | 1 |
| Distinct | 335 |
|---|---|
| Distinct (%) | 98.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2406.444282 |
| Minimum | 1913.15 |
|---|---|
| Maximum | 2819.85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1913.15 |
|---|---|
| 5-th percentile | 1997.05 |
| Q1 | 2250 |
| median | 2424.4 |
| Q3 | 2572.85 |
| 95-th percentile | 2700.4 |
| Maximum | 2819.85 |
| Range | 906.7 |
| Interquartile range (IQR) | 322.85 |
Descriptive statistics
| Standard deviation | 212.9288842 |
|---|---|
| Coefficient of variation (CV) | 0.08848278177 |
| Kurtosis | -0.5467666656 |
| Mean | 2406.444282 |
| Median Absolute Deviation (MAD) | 154.25 |
| Skewness | -0.4746055498 |
| Sum | 820597.5 |
| Variance | 45338.70972 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2425.6 | 2 | 0.6% |
| 2086 | 2 | 0.6% |
| 2227.4 | 2 | 0.6% |
| 2378.3 | 2 | 0.6% |
| 2700.4 | 2 | 0.6% |
| 2627.4 | 2 | 0.6% |
| 2672.95 | 1 | 0.3% |
| 2619.05 | 1 | 0.3% |
| 2626.05 | 1 | 0.3% |
| 2663.7 | 1 | 0.3% |
| Other values (325) | 325 |
| Value | Count | Frequency (%) |
| 1913.15 | 1 | |
| 1916.6 | 1 | |
| 1920.1 | 1 | |
| 1926.2 | 1 | |
| 1931 | 1 | |
| 1931.75 | 1 | |
| 1933.15 | 1 | |
| 1937.3 | 1 | |
| 1959.05 | 1 | |
| 1960.35 | 1 |
| Value | Count | Frequency (%) |
| 2819.85 | 1 | |
| 2798.75 | 1 | |
| 2790.25 | 1 | |
| 2782.1 | 1 | |
| 2780.45 | 1 | |
| 2779.5 | 1 | |
| 2778.35 | 1 | |
| 2775.65 | 1 | |
| 2772.75 | 1 | |
| 2767.55 | 1 |
| Distinct | 341 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2407.293959 |
| Minimum | 1915.34 |
|---|---|
| Maximum | 2823.91 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1915.34 |
|---|---|
| 5-th percentile | 1999.87 |
| Q1 | 2257.44 |
| median | 2429.46 |
| Q3 | 2574.11 |
| 95-th percentile | 2710.69 |
| Maximum | 2823.91 |
| Range | 908.57 |
| Interquartile range (IQR) | 316.67 |
Descriptive statistics
| Standard deviation | 212.6284907 |
|---|---|
| Coefficient of variation (CV) | 0.0883267662 |
| Kurtosis | -0.5413777399 |
| Mean | 2407.293959 |
| Median Absolute Deviation (MAD) | 151.79 |
| Skewness | -0.4650870878 |
| Sum | 820887.24 |
| Variance | 45210.87506 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2024.21 | 1 | 0.3% |
| 2557.8 | 1 | 0.3% |
| 2636.9 | 1 | 0.3% |
| 2658.17 | 1 | 0.3% |
| 2641.48 | 1 | 0.3% |
| 2642 | 1 | 0.3% |
| 2661.36 | 1 | 0.3% |
| 2623 | 1 | 0.3% |
| 2611.69 | 1 | 0.3% |
| 2596.66 | 1 | 0.3% |
| Other values (331) | 331 |
| Value | Count | Frequency (%) |
| 1915.34 | 1 | |
| 1920.95 | 1 | |
| 1923.26 | 1 | |
| 1925.2 | 1 | |
| 1929.4 | 1 | |
| 1932.02 | 1 | |
| 1935.83 | 1 | |
| 1940.01 | 1 | |
| 1950.25 | 1 | |
| 1958.46 | 1 |
| Value | Count | Frequency (%) |
| 2823.91 | 1 | |
| 2817.63 | 1 | |
| 2794.98 | 1 | |
| 2793.34 | 1 | |
| 2783.29 | 1 | |
| 2775.79 | 1 | |
| 2773.48 | 1 | |
| 2773.03 | 1 | |
| 2768.55 | 1 | |
| 2763.87 | 1 |
| Distinct | 341 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7056064.891 |
| Minimum | 787160 |
|---|---|
| Maximum | 42209687 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 787160 |
|---|---|
| 5-th percentile | 3455942 |
| Q1 | 4768334 |
| median | 6081627 |
| Q3 | 7973235 |
| 95-th percentile | 12223037 |
| Maximum | 42209687 |
| Range | 41422527 |
| Interquartile range (IQR) | 3204901 |
Descriptive statistics
| Standard deviation | 4343831.713 |
|---|---|
| Coefficient of variation (CV) | 0.6156167467 |
| Kurtosis | 25.1994233 |
| Mean | 7056064.891 |
| Median Absolute Deviation (MAD) | 1505516 |
| Skewness | 4.201837923 |
| Sum | 2406118128 |
| Variance | 1.886887395 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8035915 | 1 | 0.3% |
| 6077153 | 1 | 0.3% |
| 6068663 | 1 | 0.3% |
| 3659307 | 1 | 0.3% |
| 3656408 | 1 | 0.3% |
| 6102744 | 1 | 0.3% |
| 7297028 | 1 | 0.3% |
| 4007695 | 1 | 0.3% |
| 4564891 | 1 | 0.3% |
| 6563676 | 1 | 0.3% |
| Other values (331) | 331 |
| Value | Count | Frequency (%) |
| 787160 | 1 | |
| 1853948 | 1 | |
| 2216708 | 1 | |
| 2502073 | 1 | |
| 2868235 | 1 | |
| 2924370 | 1 | |
| 2941883 | 1 | |
| 3044037 | 1 | |
| 3049304 | 1 | |
| 3083747 | 1 |
| Value | Count | Frequency (%) |
| 42209687 | 1 | |
| 37841671 | 1 | |
| 32591420 | 1 | |
| 27285782 | 1 | |
| 26060864 | 1 | |
| 25546334 | 1 | |
| 19568487 | 1 | |
| 19317335 | 1 | |
| 16098099 | 1 | |
| 15525644 | 1 |
| Distinct | 341 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.693305829 × 1015 |
| Minimum | 1.965800892 × 1014 |
|---|---|
| Maximum | 9.211999493 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1.965800892 × 1014 |
|---|---|
| 5-th percentile | 8.115922559 × 1014 |
| Q1 | 1.142314756 × 1015 |
| median | 1.458916963 × 1015 |
| Q3 | 1.942001903 × 1015 |
| 95-th percentile | 3.004172516 × 1015 |
| Maximum | 9.211999493 × 1015 |
| Range | 9.015419404 × 1015 |
| Interquartile range (IQR) | 7.996871468 × 1014 |
Descriptive statistics
| Standard deviation | 1.021721954 × 1015 |
|---|---|
| Coefficient of variation (CV) | 0.6033889074 |
| Kurtosis | 23.4013569 |
| Mean | 1.693305829 × 1015 |
| Median Absolute Deviation (MAD) | 3.812314512 × 1014 |
| Skewness | 3.97562863 |
| Sum | 5.774172878 × 1017 |
| Variance | 1.043915752 × 1030 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.626633943 × 1015 | 1 | 0.3% |
| 1.554411585 × 1015 | 1 | 0.3% |
| 1.600246615 × 1015 | 1 | 0.3% |
| 9.72705226 × 1014 | 1 | 0.3% |
| 9.658325027 × 1014 | 1 | 0.3% |
| 1.612346563 × 1015 | 1 | 0.3% |
| 1.942001903 × 1015 | 1 | 0.3% |
| 1.051219846 × 1015 | 1 | 0.3% |
| 1.192209306 × 1015 | 1 | 0.3% |
| 1.704360617 × 1015 | 1 | 0.3% |
| Other values (331) | 331 |
| Value | Count | Frequency (%) |
| 1.965800892 × 1014 | 1 | |
| 4.38805404 × 1014 | 1 | |
| 5.722594257 × 1014 | 1 | |
| 5.98656851 × 1014 | 1 | |
| 6.500981051 × 1014 | 1 | |
| 6.524718783 × 1014 | 1 | |
| 6.808700909 × 1014 | 1 | |
| 7.02822628 × 1014 | 1 | |
| 7.179873286 × 1014 | 1 | |
| 7.285364915 × 1014 | 1 |
| Value | Count | Frequency (%) |
| 9.211999493 × 1015 | 1 | |
| 9.179980463 × 1015 | 1 | |
| 8.599389887 × 1015 | 1 | |
| 5.878142158 × 1015 | 1 | |
| 5.387879159 × 1015 | 1 | |
| 5.380107704 × 1015 | 1 | |
| 4.799499831 × 1015 | 1 | |
| 4.659492983 × 1015 | 1 | |
| 3.879858013 × 1015 | 1 | |
| 3.796726594 × 1015 | 1 |
| Distinct | 341 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 240334.6979 |
| Minimum | 63285 |
|---|---|
| Maximum | 1165095 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 63285 |
|---|---|
| 5-th percentile | 131393 |
| Q1 | 177038 |
| median | 219641 |
| Q3 | 274696 |
| 95-th percentile | 408746 |
| Maximum | 1165095 |
| Range | 1101810 |
| Interquartile range (IQR) | 97658 |
Descriptive statistics
| Standard deviation | 104565.6109 |
|---|---|
| Coefficient of variation (CV) | 0.4350832892 |
| Kurtosis | 20.19525305 |
| Mean | 240334.6979 |
| Median Absolute Deviation (MAD) | 46248 |
| Skewness | 3.229551421 |
| Sum | 81954132 |
| Variance | 1.093396698 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 213153 | 1 | 0.3% |
| 221309 | 1 | 0.3% |
| 204933 | 1 | 0.3% |
| 167593 | 1 | 0.3% |
| 163060 | 1 | 0.3% |
| 249443 | 1 | 0.3% |
| 219316 | 1 | 0.3% |
| 203830 | 1 | 0.3% |
| 183261 | 1 | 0.3% |
| 276908 | 1 | 0.3% |
| Other values (331) | 331 |
| Value | Count | Frequency (%) |
| 63285 | 1 | |
| 89509 | 1 | |
| 105190 | 1 | |
| 105619 | 1 | |
| 106030 | 1 | |
| 107475 | 1 | |
| 114345 | 1 | |
| 116529 | 1 | |
| 117855 | 1 | |
| 118469 | 1 |
| Value | Count | Frequency (%) |
| 1165095 | 1 | |
| 755278 | 1 | |
| 642384 | 1 | |
| 629847 | 1 | |
| 624166 | 1 | |
| 525122 | 1 | |
| 497536 | 1 | |
| 496545 | 1 | |
| 493459 | 1 | |
| 482175 | 1 |
| Distinct | 341 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3494253.824 |
| Minimum | 402932 |
|---|---|
| Maximum | 19734107 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 402932 |
|---|---|
| 5-th percentile | 1584484 |
| Q1 | 2310132 |
| median | 3012536 |
| Q3 | 4117945 |
| 95-th percentile | 6735937 |
| Maximum | 19734107 |
| Range | 19331175 |
| Interquartile range (IQR) | 1807813 |
Descriptive statistics
| Standard deviation | 2018793.697 |
|---|---|
| Coefficient of variation (CV) | 0.5777467234 |
| Kurtosis | 19.85326346 |
| Mean | 3494253.824 |
| Median Absolute Deviation (MAD) | 880867 |
| Skewness | 3.416603651 |
| Sum | 1191540554 |
| Variance | 4.075527993 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2834103 | 1 | 0.3% |
| 3208900 | 1 | 0.3% |
| 3962890 | 1 | 0.3% |
| 1859891 | 1 | 0.3% |
| 1845831 | 1 | 0.3% |
| 3893403 | 1 | 0.3% |
| 4259734 | 1 | 0.3% |
| 2280912 | 1 | 0.3% |
| 2149565 | 1 | 0.3% |
| 3821279 | 1 | 0.3% |
| Other values (331) | 331 |
| Value | Count | Frequency (%) |
| 402932 | 1 | |
| 532328 | 1 | |
| 1054022 | 1 | |
| 1082865 | 1 | |
| 1089396 | 1 | |
| 1160672 | 1 | |
| 1216161 | 1 | |
| 1230092 | 1 | |
| 1312810 | 1 | |
| 1436439 | 1 |
| Value | Count | Frequency (%) |
| 19734107 | 1 | |
| 16124097 | 1 | |
| 15742153 | 1 | |
| 9894247 | 1 | |
| 9460717 | 1 | |
| 9245255 | 1 | |
| 8925205 | 1 | |
| 8601779 | 1 | |
| 7857043 | 1 | |
| 7709766 | 1 |
%Deliverble
Real number (ℝ≥0)
| Distinct | 324 |
|---|---|
| Distinct (%) | 95.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5008601173 |
| Minimum | 0.2611 |
|---|---|
| Maximum | 0.7185 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0.2611 |
|---|---|
| 5-th percentile | 0.3484 |
| Q1 | 0.4531 |
| median | 0.5119 |
| Q3 | 0.5598 |
| 95-th percentile | 0.6337 |
| Maximum | 0.7185 |
| Range | 0.4574 |
| Interquartile range (IQR) | 0.1067 |
Descriptive statistics
| Standard deviation | 0.08567782192 |
|---|---|
| Coefficient of variation (CV) | 0.1710613781 |
| Kurtosis | -0.007676732985 |
| Mean | 0.5008601173 |
| Median Absolute Deviation (MAD) | 0.0543 |
| Skewness | -0.4086686431 |
| Sum | 170.7933 |
| Variance | 0.007340689169 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.4597 | 2 | 0.6% |
| 0.5952 | 2 | 0.6% |
| 0.4711 | 2 | 0.6% |
| 0.5437 | 2 | 0.6% |
| 0.4953 | 2 | 0.6% |
| 0.5752 | 2 | 0.6% |
| 0.4815 | 2 | 0.6% |
| 0.5521 | 2 | 0.6% |
| 0.5204 | 2 | 0.6% |
| 0.5877 | 2 | 0.6% |
| Other values (314) | 321 |
| Value | Count | Frequency (%) |
| 0.2611 | 1 | |
| 0.2629 | 1 | |
| 0.2815 | 1 | |
| 0.2833 | 1 | |
| 0.2871 | 1 | |
| 0.2876 | 1 | |
| 0.293 | 1 | |
| 0.2951 | 1 | |
| 0.3068 | 1 | |
| 0.3079 | 1 |
| Value | Count | Frequency (%) |
| 0.7185 | 1 | |
| 0.6902 | 1 | |
| 0.6858 | 1 | |
| 0.6689 | 1 | |
| 0.6667 | 1 | |
| 0.659 | 1 | |
| 0.6535 | 1 | |
| 0.653 | 1 | |
| 0.649 | 1 | |
| 0.6453 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Date | Symbol | Series | Prev Close | Open | High | Low | Last | Close | VWAP | Volume | Turnover | Trades | Deliverable Volume | %Deliverble | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021-04-29 | RELIANCE | EQ | 1997.30 | 2022.90 | 2044.50 | 2007.30 | 2020.00 | 2024.05 | 2024.21 | 8035915 | 1.626634e+15 | 213153 | 2834103 | 0.3527 |
| 1 | 2021-04-30 | RELIANCE | EQ | 2024.05 | 2008.50 | 2036.00 | 1987.55 | 1995.90 | 1994.50 | 2010.20 | 9150974 | 1.839532e+15 | 288687 | 3902504 | 0.4265 |
| 2 | 2021-05-03 | RELIANCE | EQ | 1994.50 | 1966.00 | 1979.00 | 1943.10 | 1956.00 | 1959.05 | 1958.46 | 10909942 | 2.136664e+15 | 343806 | 3800598 | 0.3484 |
| 3 | 2021-05-04 | RELIANCE | EQ | 1959.05 | 1950.00 | 1967.80 | 1911.00 | 1918.00 | 1916.60 | 1935.83 | 10083693 | 1.952033e+15 | 325798 | 4435071 | 0.4398 |
| 4 | 2021-05-05 | RELIANCE | EQ | 1916.60 | 1923.35 | 1938.50 | 1908.05 | 1921.50 | 1920.10 | 1923.26 | 5719649 | 1.100036e+15 | 190990 | 1762417 | 0.3081 |
| 5 | 2021-05-06 | RELIANCE | EQ | 1920.10 | 1921.85 | 1935.00 | 1906.60 | 1932.00 | 1931.00 | 1920.95 | 6749281 | 1.296502e+15 | 221666 | 2830835 | 0.4194 |
| 6 | 2021-05-07 | RELIANCE | EQ | 1931.00 | 1937.75 | 1955.65 | 1926.00 | 1926.80 | 1931.75 | 1940.01 | 5671163 | 1.100213e+15 | 188670 | 2418447 | 0.4264 |
| 7 | 2021-05-10 | RELIANCE | EQ | 1931.75 | 1939.00 | 1946.80 | 1920.95 | 1927.10 | 1926.20 | 1932.02 | 6433879 | 1.243036e+15 | 197986 | 2996697 | 0.4658 |
| 8 | 2021-05-11 | RELIANCE | EQ | 1926.20 | 1915.00 | 1938.55 | 1910.00 | 1933.90 | 1933.15 | 1929.40 | 6220217 | 1.200129e+15 | 175976 | 3035544 | 0.4880 |
| 9 | 2021-05-12 | RELIANCE | EQ | 1933.15 | 1930.10 | 1932.90 | 1907.00 | 1913.05 | 1913.15 | 1915.34 | 6081627 | 1.164838e+15 | 212378 | 2760797 | 0.4540 |
Last rows
| Date | Symbol | Series | Prev Close | Open | High | Low | Last | Close | VWAP | Volume | Turnover | Trades | Deliverable Volume | %Deliverble | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 331 | 2022-08-26 | RELIANCE | EQ | 2632.05 | 2633.00 | 2650.00 | 2607.00 | 2623.00 | 2618.00 | 2622.30 | 4957449 | 1.299993e+15 | 191312 | 2885652 | 0.5821 |
| 332 | 2022-08-29 | RELIANCE | EQ | 2618.00 | 2585.00 | 2655.00 | 2578.05 | 2600.00 | 2597.65 | 2614.34 | 9155684 | 2.393607e+15 | 326003 | 3737011 | 0.4082 |
| 333 | 2022-08-30 | RELIANCE | EQ | 2597.65 | 2614.00 | 2645.25 | 2576.60 | 2642.00 | 2637.95 | 2614.74 | 10678670 | 2.792198e+15 | 285656 | 5624355 | 0.5267 |
| 334 | 2022-09-01 | RELIANCE | EQ | 2637.95 | 2582.65 | 2604.95 | 2550.70 | 2564.00 | 2560.40 | 2580.13 | 9188434 | 2.370736e+15 | 346414 | 5658983 | 0.6159 |
| 335 | 2022-09-02 | RELIANCE | EQ | 2560.40 | 2560.40 | 2575.35 | 2525.70 | 2527.95 | 2530.50 | 2546.24 | 5999196 | 1.527538e+15 | 266158 | 3185305 | 0.5310 |
| 336 | 2022-09-05 | RELIANCE | EQ | 2530.50 | 2531.00 | 2581.50 | 2531.00 | 2567.15 | 2569.80 | 2563.92 | 5227785 | 1.340362e+15 | 189614 | 2658456 | 0.5085 |
| 337 | 2022-09-06 | RELIANCE | EQ | 2569.80 | 2573.00 | 2606.00 | 2572.00 | 2594.00 | 2596.85 | 2592.68 | 5030172 | 1.304165e+15 | 174426 | 2588620 | 0.5146 |
| 338 | 2022-09-07 | RELIANCE | EQ | 2596.85 | 2575.00 | 2594.90 | 2570.00 | 2580.50 | 2581.75 | 2580.95 | 3455942 | 8.919602e+14 | 117855 | 1724115 | 0.4989 |
| 339 | 2022-09-08 | RELIANCE | EQ | 2581.75 | 2588.25 | 2598.00 | 2571.00 | 2583.05 | 2585.40 | 2583.54 | 3256840 | 8.414188e+14 | 116529 | 1821103 | 0.5592 |
| 340 | 2022-09-09 | RELIANCE | EQ | 2585.40 | 2610.00 | 2610.00 | 2564.00 | 2568.90 | 2569.30 | 2577.69 | 3837302 | 9.891380e+14 | 185947 | 2149444 | 0.5601 |